-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: 62.149.150.108
-- Generato il: 26 lug, 2010 at 01:34 PM
-- Versione MySQL: 5.0.91
-- Versione PHP: 5.2.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;




CREATE TABLE IF NOT EXISTS categories (
  category_id int(11) NOT NULL auto_increment,
  category_text varchar(255) NOT NULL,
  PRIMARY KEY  (category_id),
  UNIQUE KEY category_name (category_text)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;



CREATE TABLE IF NOT EXISTS languages (
  language_id int(11) NOT NULL auto_increment,
  language_text varchar(255) NOT NULL,
  PRIMARY KEY  (language_id),
  UNIQUE KEY language_text (language_text)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;



CREATE TABLE IF NOT EXISTS messages (
  message_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL,
  product_id int(11) NOT NULL,
  message_type int(11) NOT NULL,
  message_text text NOT NULL,
  PRIMARY KEY  (message_id),
  KEY language_id (language_id),
  KEY product_id (product_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;



CREATE TABLE IF NOT EXISTS products (
  product_id int(11) NOT NULL auto_increment,
  product_code varchar(32) NOT NULL,
  category_id int(11) NOT NULL,
  product_price decimal(10,2) NOT NULL,
  PRIMARY KEY  (product_id),
  UNIQUE KEY product_code (product_code),
  KEY product_category (category_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
